{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["สมาชิก กบข.","ไม่เป็น กบข.","ex"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"สมาชิก กบข.","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,8,1,11],[1,1,1,5]]}
[]
[null,"คำนวณเงินเดือนเฉลี่ย 60 เดือน สุดท้าย",null,null,null,null,null,"ชื่อ นามสกุล "]
[]
[null,null,"ปีปัจจุบัน",null,"ย้อนหลังปีที่ 1",null,"ย้อนหลังปีที่ 2",null,"ย้อนหลังปีที่ 3",null,"ย้อนหลังปีที่ 4"]
[null,1,52500,13,52500,25,52500,37,52500,49,52500]
[null,2,52500,14,52500,26,52500,38,52500,50,52500]
[null,3,52500,15,52500,27,52500,39,52500,51,52500]
[null,4,52500,16,52500,28,52500,40,52500,52,52500]
[null,5,52500,17,52500,29,52500,41,52500,53,52500]
[null,6,52500,18,52500,30,52500,42,52500,54,52500]
[null,7,52500,19,52500,31,52500,43,52500,55,52500]
[null,8,52500,20,52500,32,52500,44,52500,56,52500]
[null,9,52500,21,52500,33,52500,45,52500,57,52500]
[null,10,52500,22,52500,34,52500,46,52500,58,52500]
[null,11,52500,23,52500,35,52500,47,52500,59,52500]
[null,12,52500,24,52500,36,52500,48,52500,60,52500]
[]
[]
[null,{"$f":"IF(K19=0,\"\",\"  70% ของเงินเดือนเฉลี่ย = \"&FIXED(K19,2)&\" x 70% = \"&FIXED(K19*0.7,2)&\" บาท\")","v":"  70% ของเงินเดือนเฉลี่ย = 52,500.00 x 70% = 36,750.00 บาท"},null,null,null,null,null,null,null,"เงินเดือนเฉลี่ย 60 เดือนสุดท้าย  ",{"$f":"IFERROR(AVERAGE(C5:C16,E5:E16,G5:G16,I5:I16,K5:K16),0)","v":52500}," บาท"]
[]
[null,null,null,null,null,null,null,null,null,"อายุราชการ  ",35.5," ปี"]
[]
[null,null,null,null,null,null,null,null,null,"เงินบำนาญเดือนละ  ",{"$f":"IF(K21=\"\",\"\",IF(K19*K21/50>K19*0.7,K19*0.7,K19*K21/50))","v":36750}," บาท"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(\"(\"&BAHTTEXT(K23)&\")\",\"\")","v":"(สามหมื่นหกพันเจ็ดร้อยห้าสิบบาทถ้วน)"}]

{"sheet":"ไม่เป็น กบข.","index":1,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,11],[18,1,18,6]]}
[]
[null,"กรณีไม่เป็นสมาชิก กบข.",null,null,null,null,null,"ชื่อ นามสกุล "]
[]
[]
[]
[null,null,"กรณีไม่เป็นสมาชิก กบข. ให้ระบุเงินเดือนของเดือนสุดท้าย"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(K19=0,\"\",IF(K21=0,\"\",\"  = \"&FIXED(K19,2)&\" x \"&FIXED(K21,2)&\" / 50 = \"&FIXED(K19*K21/50,2)&\" บาท\"))","v":""},null,null,null,null,null,null,null,"เงินเดือน เดือนสุดท้าย  ",null," บาท"]
[]
[null,null,null,null,null,null,null,null,null,"อายุราชการ  ",null," ปี"]
[]
[null,null,null,null,null,null,null,null,null,"เงินบำนาญเดือนละ  ",{"$f":"K19*K21/50","v":0}," บาท"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(\"(\"&BAHTTEXT(K23)&\")\",\"\")","v":"(ศูนย์บาทถ้วน)"}]

{"sheet":"ex","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[1,55780,13,53930,25,50920,37,48360,49,45980]
[2,55780,14,53930,26,50920,38,48360,50,45980]
[3,55780,15,53930,27,50920,39,48360,51,45980]
[4,55780,16,53930,28,50920,40,48360,52,45980]
[5,55780,17,53930,29,50920,41,48360,53,45980]
[6,55780,18,53930,30,50920,42,48360,54,45980]
[7,55780,19,52200,31,49640,43,47170,55,44790]
[8,55780,20,52200,32,49640,44,47170,56,44790]
[9,55780,21,52200,33,49640,45,47170,57,44790]
[10,55780,22,52200,34,49640,46,47170,58,44790]
[11,55780,23,52200,35,49640,47,47170,59,44790]
[12,55780,24,52200,36,49640,48,47170,60,44790]